Skip Headers

Oracle® OLAP Reference 10g Release 2 (10.2) Part Number B14350-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# Views of Cached Active Catalog Metadata

The Metadata Reader Views for the Active Catalog, named with the prefix `MRV_OLAP2_AW`, present a read API to a set of cache tables for the Active Catalog. These views and tables are structured to facilitate query performance for the OLAP API.

The `MRV_OLAP2_AW` views correspond to the `ALL_OLAP2_AW` views, which provide information about standard form metadata within analytic workspaces. Each `MRV_OLAP2_AW` view has the same name and column structure as its corresponding `ALL_OLAP2_AW` view. If you require fast access to the Active Catalog, you should query the cached metadata through the `MRV_OLAP2_AW` views.

The cache tables are not automatically refreshed when changes are made to the Active Catalog. To refresh the cache, call the `CWM2_OLAP_METADATA_REFRESH.MR_AC_REFRESH` procedure.

Note: If your data is stored in analytic workspaces, you should refresh the Active Catalog cache for applications that use the OLAP API.

# Summary of CWM2_OLAP_METADATA_REFRESH Subprograms

Table 19-1 CWM2_OLAP_METADATA_REFRESH Subprograms

Subprogram | Description
--- | ---
MR_REFRESH Procedure | Refreshes the OLAP Catalog metadata cache.
MR_AC_REFRESH Procedure | Refreshes the Active Catalog metadata cache.

## MR_REFRESH Procedure

This procedure refreshes the OLAP Catalog metadata cache tables that underlie the `MRV_OLAP2` views. You must refresh the cache for applications that use the OLAP API with a relational data source.

The `MR_REFRESH` procedure includes a `COMMIT`.

Syntax

    MR_REFRESH;

See Also

"Validating and Committing OLAP Catalog Metadata" and "OLAP Catalog Metadata Cache".

## MR_AC_REFRESH Procedure

This procedure refreshes the Active Catalog metadata cache tables that underlie the `MRV_OLAP2_AW` views. You must refresh the cache for applications that use the OLAP API with a multidimensional data source in analytic workspaces.

The `MR_AC_REFRESH` procedure includes a `COMMIT`.

Syntax

    MR_AC_REFRESH;

See Also

"Active Catalog Metadata Cache".